CREATE TABLE `student` (
  `student_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `student_number` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_class` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_major` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_school` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

BEGIN;
INSERT INTO `student` (`student_id`, `student_number`, `student_name`, `student_class`, `student_major`, `student_school`) VALUES (1, '1', 'stu', '1', '1', '1');
INSERT INTO `student` (`student_id`, `student_number`, `student_name`, `student_class`, `student_major`, `student_school`) VALUES (2, '2', '2', '2', '2', '2');
INSERT INTO `student` (`student_id`, `student_number`, `student_name`, `student_class`, `student_major`, `student_school`) VALUES (4, '001', '测试', 'XX', 'XX', 'XX');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;